Discover gists

DynamoDB Query Evaluation Order Differs from SQL

Summary:

When using LIMIT in DynamoDB queries, the order of evaluation can differ from SQL queries, potentially leading to unexpected results depending on the search criteria used.

SQL Query Evaluation Order:

SQL queries follow a specific order of evaluation:

FROM -&gt; ON -&gt; JOIN -&gt; WHERE -&gt; GROUP BY -&gt; HAVING -&gt; SELECT -&gt; DISTINCT -&gt; ORDER BY -&gt; LIMIT

Удалить/очистить все данные Докера (контейнеры, образы, тома и сети)

Одной строкой

docker stop $(docker ps -qa) && docker rm $(docker ps -qa) && docker rmi -f $(docker images -qa) && docker volume rm $(docker volume ls -q) && docker network rm $(docker network ls -q)

Описание команд

Instructions for a mac on how to play with pyenv and poetry

Why both? Pyenv to manage multiple python versions. You can make virtualenvs with pyenv of course, but using poetry will simplify that process

# Install pyenv.
brew install pyenv

# Add pyenv initializer to shell startup script.
echo -e '\nif command -v pyenv 1>/dev/null 2>&1; then

The repository for the assignment is public and Github does not allow the creation of private forks for public repositories.

The correct way of creating a private frok by duplicating the repo is documented here.

For this assignment the commands are:

Create a bare clone of the repository. (This is temporary and will be removed so just do it wherever.)

git clone --bare git@github.com:usi-systems/easytrace.git

Complete Recent Discord Quest

Note

This no longer works in browser!

Note

This no longer works if you're alone in vc! Somebody else has to join you!

How to use this script:

Accept the quest under User Settings -> Gift Inventory

	<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
	<CodeBlocksConfig version="1">
	<editor>
	<colour_sets>
	<ACTIVE_COLOUR_SET>
	<str>
	<![CDATA[modnokai night shift v2]]>
	</str>
	</ACTIVE_COLOUR_SET>
	<ACTIVE_LANG>

	#!/usr/bin/python
	#!/usr/bin/env python

	import os
	import glob
	import time
	import RPi.GPIO as GPIO
	import sys, getopt
	import decimal

	#!/usr/bin/python

	import RPi.GPIO as GPIO
	import time
	import subprocess, os
	import signal
	GPIO.setmode(GPIO.BCM)
	GPIO.setwarnings(False)
	RearView_Switch = 14 # pin 18
	Brightness_Switch = 15 # pin 16

	#!/bin/bash

	level=$1
	#echo "level given is $level"

	if [ $# != 1 ]; then
	echo "USAGE: $0 brightness_level (0 to 255)"
	exit 1
	fi

	#!/usr/bin/python
	# A quick hack of my button monitor script to monitor headlights and reverse lights to
	# Dim the screen and switch to the reverse camera.
	# I have not tested this...
	# Remember, the switch or opto is switching to ground, so the logic is inverted... 0 = on 1 = off
	# Also, you would run only one of these "Monitor" scripts. you can't be running RearviewMonitor.py AND LightMonitor.py

	import RPi.GPIO as GPIO
	import time
	import subprocess, os